---
title: DB-CLL-035 — Update a legal case evaluation
summary: Update a legal case evaluation
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-035 — Update a legal case evaluation

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-035 |
| Operation type | U |
| Execution method | StoredProc |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Stored procedure call |
| Business object | clsLegalCaseEvaluation |
| Criteria property | UpdateSQL |
| Lifecycle method | BeforeUpdate |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseEvaluationID | Input | NUMBER | N/A | Evaluation identifier to update |
| EvaluationDate | Input | DATE | N/A | Date of evaluation |
| UpdateUser | Input | VARCHAR2 | N/A | User performing the update |
| UpdateDate | Input | DATE | N/A | Update timestamp |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [LEGAL_CASE_EVALUATION](../database-tables.md#legal_case_evaluation) | UPDATE | ~8 columns (inferred*) |

## Sample SQL

```sql
EXEC pk80001_legalnet.updateLCE(:LegalCaseEvaluationID, :EvaluationDate, :UpdateUser,
  :UpdateDate, :EvaluatorEmplid, :EvaluationComments,
  :ReviewLevelCode);  -- final 3 params inferred from remaining evaluation-detail columns*; proc name inferred*
```

## Operations and processes

- [Manage legal case evaluations](../operations/manage-legal-case-evaluation.md)

## Business rules

- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb`